import pandas as pd
data=[[110,120,105],[95,110,108],[98,80,100],[112,106,97]]
index=['王蒙','李珊','赵胜','刘文']
columns=['数学','语文','英语']
df=pd.DataFrame(data,index,columns)
print('保存的数据:\n',df)
writer=pd.ExcelWriter('Score1.xlsx')
df.to_excel(writer,sheet_name='school')
df.iloc[0]=[105,118,100]
print('保存到score2工作表中的数据:\n',df)
df.to_excel(writer,sheet_name='Score2')
writer._save()
df1=pd.read_excel('Score.xlsx',sheet_name=['school','school'],index_col=0)
print('导入的数据:\n',df)